package cn.itqiqi.student_system_java.mapper;

import cn.itqiqi.student_system_java.pojo.ClassNumVo;
import cn.itqiqi.student_system_java.pojo.Course;
import cn.itqiqi.student_system_java.pojo.Score;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @author kevin_琪琪
 * @version 1.0
 * @description
 * @date 2022-06-20 17:44
 */
@Mapper
public interface ScoreMapper {

    List<Score> getScoreAll(Page<Score> page);
    int getClassNum();
    List<Course> getCourseAll();
    List<String> getStuAll();
    ClassNumVo getClassInfo(int classId);
    List<ClassNumVo> getStuInfo(int classId);
    List<Score> getCourseByName(Page<Score> page, String sname);
    List<Score> getCourseByCourse(Page<Score> page, String cname);
    void scoreAdd(int stuId, int courseId, int score);
    int scoreNum(int stuId, int courseId);
    void updateScore(int id, int score);
    void deleteScore(int id);

}
